RecallEventItem

Entity Definition

Logical Name : RecallEventItem
Physical Name : CO_RCL_EV_ITM

The set of items or inventory items that are impacted by a recall event. These items may be identified directly in the original recall or may be identified by tracing their application to the recall via traceability: contact with equipment, contact with specific workers, contact with other ingredients, location of items, or parent item or inventory item components

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
EventID (FK)(PK)	A token used to identify an object, represented as an Integer.	ID_EV	Identity	integer	RecallEvent(CO_RCL_EV)
RecallEventSequenceNumber (PK)	A number, that together with a recall event ID, uniquely indentifies a recall event item or inventory item.	AI_RCL_EV	Identity	integer
ItemTraceableUnitID (FK)	A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item.	ID_ITM_UN_TRC	IdentityUUID	CHAR(32)	ItemTraceableUnit(AS_ITM_TRCBL_UN)

Relationships

Parent Entity	Verb Phrase	Child Entity
RecallEvent	impacts	RecallEventItem
ItemTraceableUnit	is contained on	RecallEventItem

Logical Views containing RecallEventItem

Logical View
Logical 21000 - Fresh Item Management Macro View